﻿CREATE PROCEDURE DeleteCargo( @CodeGNG nchar(8) )
AS
BEGIN
	DELETE FROM Cargo 
	WHERE Cargo.CodeGNG = @CodeGNG

	DELETE FROM CargoETSNG
	WHERE CargoETSNG.CargoGNG_ID = @CodeGNG

	DELETE FROM CargoGNG
	WHERE CargoGNG_ID = @CodeGNG
END